home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The World of Computer Software
/
The World of Computer Software.iso
/
cmqck102.zip
/
CIMQUICK.DOC
< prev
next >
Wrap
Text File
|
1993-01-17
|
7KB
|
132 lines
CIMQUICK 1.02
Copyright (c) 1991-1992 by Jonathan Wayne
Compuserve ID 71640,345
CIMQUICK is a small freeware utility that will convert a CIM stock quotes
file into a format suitable for Quicken to import. Simply type in
cimquick inputfilename > outputfilename
where inputfilename is the name (and path if it isn't in the current
directory) of the CIM quotes file and outputfilename is the name of the
file that you want to create for importing into Quicken. For example,
cimquick \cim\untitled.txt > \quicken\import.txt
will use the CIM quotes file "untitled.txt" in the \cim subdirectory and
will create the file "import.txt" in the \quicken subdirectory. If you
leave out the output file name, the output will go to the screen. This can
be useful if you wish to preview what CIMQUICK would create.
The output (created) file consists of stock symbols and closing prices, one
set per line. You can then import the file "import.txt" by typing in the
file name in the "Import Price Data" window (again, you must supply the
complete path if it isn't in the current directory.) This is invoked by
first selecting Update Prices from the Activities menu when in an
investment register, and then selecting Import Prices from the Print/Acct
menu (a quicker way is to press <Ctrl-U> to get to the Update Menu and then
pressing <Ctrl-I> to get to the Import Price window. See the section in
the Quicken 5 manual under "Importing Security Prices" for more detail.
Note that CIMQUICK does not supply any dates in the output file. You should
therefore change the date of the quotes file in the "Import Price Data"
window if it is other than the current date.
If you type in the command
cimquick
by itself, you will see a help screen similar to, but more abbreviated
than, this document.
IMPORTANT: The input (captured) file MUST adhere to certain requirements.
Besides the formatting requirements mentioned below, it must be plain text
file. Don't modify it with a word processor and expect CIMQUICK to work.
Plain text editors are ok, but remember that it is possible to crash your
machine if the input file deviates from what CIMQUICK expects. Some
precautions have been taken to avoid possible problems, but it is your
responsibility to ensure that your input file adheres to program
specifications.
ALSO IMPORTANT: Don't use the same name for the original and new files.
Doing so may destroy the original before the program completes!
Note 1: If you use other communication programs to access Compuserve, you
can also use CIMQUICK by capturing a file output by the "qquote" service.
Just make sure that you specify the stock symbol as the first field and the
closing price as the fifth field. For example, use:
/ITEMS=1,2,3,4,5
There must not be spaces within any of the first five fields, since
CIMQUICK basically parses by spaces. So if you capture the full stock
name, it should be after the fifth field.
Note 2: You can also use the file created by CIMQUICK to import into Lotus
1-2-3 and other spreadsheets. I have a master file that contains all
stocks and prices which is referenced by other spreadsheets. A NDOS alias
(you can also use CED or a batch file) does the following:
1) Runs the following Procomm script
; logon commands here
DOS "del c:\lotus\wk1\stock.raw" ; delete the old quotes file
TRANSMIT "go qquote!" ; go to the qquote section
WAITFOR "Issue:" 45 ; wait for the Issue prompt
TRANSMIT "/ITEMS=1,3,4,5,6,2!" ; items specifier (see above)
WAITFOR "Issue:" 10 ; wait for the Issue prompt
TRANSMIT "@quotes!" ; transmit qquote symbols file
LOG OPEN "c:\lotus\wk1\stock.raw" ; capture output to file
WAITFOR "Issue:" 75 ; wait for the Issue prompt
LOG CLOSE ; close output file
; logoff commands here
2) Prepares the quotes file, "stock.dat"
CIMQUICK \lotus\wk1\stock.raw \lotus\wk1\stock.dat
3) Starts 123 (and loads master.wk1 using "stackey" commands)
4) Imports the stock.dat file with the following macro
{goto}B3~ - go to the proper place to import file
/finstock.dat~ - this imports stock.dat
/rnlr.{end}{down}~ - create range names based on symbols
/fs~r/fr{NAME} - save the file
5) My other worksheets can then reference the prices in the master.wk1
file based on the range names (but if you have other information in the
spreadsheet, it is crucial that you maintain a proper order of symbols
in your qquotes file)
ETCETERA
CIMQUICK doesn't do anything weird that might mess up files, disks, the
ozone layer or whatever, but just for the sake of completeness let me say
that I AM NOT RESPONSIBLE for any damages, direct or incidental, that might
arise out of the use of this program. And please keep in mind that in
these troubling times, one must take responsibility as a computer user to
ensure that one is using and sharing only virus-free programs!
CIMQUICK is free. No strings attached. But if you share CIMQUICK with
other individuals and bulletin boards, the documentation and executable
must be distributed together, without modification. No one is allowed any
monetary compensation for disbursing this program, other than reasonable
media costs.
This version (1.02) fixes a bug with certain ticker symbols. Previously,
if the quotes file had symbols with embedded spaces (e.g., "DJ 30" or "SP
500"), the wrong field would be output as the closing price. Since I never
used such tickers (excuses, excuses), this escaped my attention until
someone pointed it out. Sorry.
Please feel free to criticize, comment, or suggest. For example, until I
upgrade I'd appreciate any information as to compatibility with Quicken for
Windows 2.0.
CIS email: 71640,345
US mail: Jonathan Wayne
977 Byron Ave
Elizabeth, NJ 07208
CIMQUICK is written in Borland International's Turbo C++.
===========================================================================
end of documentation for CIMQUICK